USE [aspnetdb]
GO

-- =============================================
-- Author     :		Lohith Ram D V
-- Create date:         08/mar/2011
-- =============================================

create procedure sp_GetDocID(
	@par_doc_title varchar(50), 
	@par_userid int)

AS
	SELECT [Document].doc_id
	FROM [Document] where  [Document].user1_id = @par_userid and [Document].doc_title=@par_doc_title  
	
	RETURN
